UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1I9b044DxWX381kquho0CaAM5RyZBH0q0lj9Jzj0t9M='
WHERE
key_id = '7fc19007bf5edb7176e44ef36f237fb94d42c88979c36d1d3a6783da6b22af7f'
AND (
token = '1I9b044DxWX381kquho0CaAM5RyZBH0q0lj9Jzj0t9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)