UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pz0aCnxexALyDf9n7hd3v7WXTWzwfOqrFHsHwtSwX7A='
WHERE
key_id = 'fc1c2890c7db1f2945d2027b67b9532be4228ec83b969a57824067ff780ea90c'
AND (
token = 'pz0aCnxexALyDf9n7hd3v7WXTWzwfOqrFHsHwtSwX7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)