UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KdjHmiG6wjsB7u15QyDOQRXMSTG6Xwm/LMm9bYuMm80='
WHERE
key_id = '8d02762ae657f3d204a7a07dc09175fb1cbb1b6a753c57de7330c070f6af4cb1'
AND (
token = 'KdjHmiG6wjsB7u15QyDOQRXMSTG6Xwm/LMm9bYuMm80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)