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