UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xWUw+mOX0Bcn2AZcuurrnG+xpbL/7cfXwa4B2Jkb6M='
WHERE
key_id = 'c6f323dafb79822d63ae7f147611b5a12fd64aabc81517717bda0d941418eb1b'
AND (
token = '8xWUw+mOX0Bcn2AZcuurrnG+xpbL/7cfXwa4B2Jkb6M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)