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