UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y6JyWUMERbGOCDEUcUpfZJh742N8qFs0l+z6RUhMbmc='
WHERE
key_id = 'd2fbe19cab0218696f4cb66d62f99a2b950420cc6d4975759ce310374523173e'
AND (
token = 'y6JyWUMERbGOCDEUcUpfZJh742N8qFs0l+z6RUhMbmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)