UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lg/zXayBGF4rs16bALfSQg+w/81bZtwTw6VEoG/qz4='
WHERE
key_id = '6b4a7be62dabb38bf41acd1f0ee8e43c01a54f8dc117e36b14cffe170f5a1dbc'
AND (
token = '4lg/zXayBGF4rs16bALfSQg+w/81bZtwTw6VEoG/qz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)