UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhNRg9LZqDsDbaHEhQcmNr060UHI275cEt0WHhU7kXs='
WHERE
key_id = '7ecfdb772716f1c5a4e69afee3d9e874a97931a22ca0c586e7042d2ca921acb4'
AND (
token = 'BhNRg9LZqDsDbaHEhQcmNr060UHI275cEt0WHhU7kXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)