UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZkx09VtG77OQJF1bDxCgyNDET70poTGAj7jYp47S1o='
WHERE
key_id = 'ad9cb9b874f904ac507a16e512850ce4561c496361c2081446be4499e98ddf91'
AND (
token = 'tZkx09VtG77OQJF1bDxCgyNDET70poTGAj7jYp47S1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)