UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'csVN4MMyT5mpU+uj23GuYseIjFgW/RkkFlLNk/xM3Gs='
WHERE
key_id = 'af9d863e08719f6257619d6580d2ad2555e7e7f667062010a4ff98fe551ef8f0'
AND (
token = 'csVN4MMyT5mpU+uj23GuYseIjFgW/RkkFlLNk/xM3Gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)