UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GPFifzPL3wyrleE7oOXuNVla51Ios1cKBi610f5k468='
WHERE
key_id = '77cdf8f761732fb27fe6419009468d680017c6048c19e81bc124de142e2c800d'
AND (
token = 'GPFifzPL3wyrleE7oOXuNVla51Ios1cKBi610f5k468='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)