UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9db8H6tmROJW4142rzudUXc56jjEfZt4JdCZDuN0jw='
WHERE
key_id = '9dfc243af61b2f3cbacc6d5fff787803aaa23876e5a441d87441d0fafb504ed0'
AND (
token = 'N9db8H6tmROJW4142rzudUXc56jjEfZt4JdCZDuN0jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)