UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I3KTuNJUyLkzZdo0b9HodzJk2eo8196Ck8KM30o+rkY='
WHERE
key_id = '34ecdee0782212900041beb4d18969ef2aad8b2074cfe2d8deb3a44a2d789802'
AND (
token = 'I3KTuNJUyLkzZdo0b9HodzJk2eo8196Ck8KM30o+rkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)