UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGSU5i0Jend6kRLhe7NVzg7i2GUtNFYEDegseUfWrNU='
WHERE
key_id = '7c7484636f9f597d241077d1dc30f7b3a68566ced40bfb910f473ca1f7f62de6'
AND (
token = 'pGSU5i0Jend6kRLhe7NVzg7i2GUtNFYEDegseUfWrNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)