UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bE7Bx4AI5Fx/wHe+TTB4vVwRVFWImbH6JTN3O33aW6Y='
WHERE
key_id = 'd36a408c2de98034206a0fcf361814f319b926e383c11647f172334e82a69497'
AND (
token = 'bE7Bx4AI5Fx/wHe+TTB4vVwRVFWImbH6JTN3O33aW6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)