UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8NwB7bR3AsBYyvHgm7j5XHDoWMNRKOU1fNxiaV26pvc='
WHERE
key_id = 'cd13566871427544056b5814134404ee43253a6d0a5c08f161102b22dd61fb02'
AND (
token = '8NwB7bR3AsBYyvHgm7j5XHDoWMNRKOU1fNxiaV26pvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)