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