UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nCb8jrdmwXOBovFcB6WuS6tJUyIKKLfWNNyNWG6JdS0='
WHERE
key_id = '0fecb1a1d8bf833dee4052265f773ecca93631a6a3422e91edf18c7c3ad690ee'
AND (
token = 'nCb8jrdmwXOBovFcB6WuS6tJUyIKKLfWNNyNWG6JdS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)