UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lvxXZVRM6oHPhWOFYSC/7N1Wpp5H83CihJKSJas7jA='
WHERE
key_id = '4ee367d6e137f7170ede2b49594971f8644f942f3c1fd5f2615c9fe593f84bb8'
AND (
token = '/lvxXZVRM6oHPhWOFYSC/7N1Wpp5H83CihJKSJas7jA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)