UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n1jpCiK99/53LbteMubh8T1yQE+ZLnYy57hp1jDOm20='
WHERE
key_id = '9a0d0dfea6f226cc722525b924e981ce10e1755313a4097d3ed41b5166a8f4e4'
AND (
token = 'n1jpCiK99/53LbteMubh8T1yQE+ZLnYy57hp1jDOm20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)