UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '36+wa/HV3q0xY8S06Ui0ZpHqS1hPdAxvbIEADHC0CYY='
WHERE
key_id = '179c947828fcdbee5dcfc2db81e1956ed91412b01d44f14aa0703993e00f8587'
AND (
token = '36+wa/HV3q0xY8S06Ui0ZpHqS1hPdAxvbIEADHC0CYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)