UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9P9Lvosufzy920GkJ7awa2b0wlOJIyT0+h/pQHZX2E='
WHERE
key_id = '5c91cf938bf09838a86336a5608a363e7a9f089f89c7cb8f3e08680a1d6f98ad'
AND (
token = 'N9P9Lvosufzy920GkJ7awa2b0wlOJIyT0+h/pQHZX2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)