UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hatb/SdTtDz1OK4/1dbhU7C2wAA2Zc7RP+9VJxkWg9w='
WHERE
key_id = '20de7d8816f2c5830f589b54cff449c74a462c385abbc08c3487c0f7e618c54f'
AND (
token = 'Hatb/SdTtDz1OK4/1dbhU7C2wAA2Zc7RP+9VJxkWg9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)