UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6aPhriyj8dzH9mzioR5Li8kC2UV0KeOt9N7U7dOs/Cg='
WHERE
key_id = '8afe1eed848f6b2c51d1ea7e57afb856b7064f1ac9714ac2a465384112d9bc97'
AND (
token = '6aPhriyj8dzH9mzioR5Li8kC2UV0KeOt9N7U7dOs/Cg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)