UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OTplJiL+Zr/db2TCIDhjRiFWWjUXvOYbhpB3cnmmNMM='
WHERE
key_id = '9deec7190cdd261efd377f256a7291ddbe051cc58be846f03a52423ff98e6a80'
AND (
token = 'OTplJiL+Zr/db2TCIDhjRiFWWjUXvOYbhpB3cnmmNMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)