UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U8KIzj2Fm4uHA6xeI/MmKi/UC0hTkIiOnr8TCa7vvz8='
WHERE
key_id = 'ffae1108021bab04884f46a99ffa2d49b628a2531ad09759739b65d01a30468f'
AND (
token = 'U8KIzj2Fm4uHA6xeI/MmKi/UC0hTkIiOnr8TCa7vvz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)