UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzlkQB2zuCaMk3hq9F9dVgT6KuFovfdCV5Fecb+rato='
WHERE
key_id = 'ebfeef6177f8681f955fb2cb9c89025a4be8b49a20762687e286f603a9230c4a'
AND (
token = 'hzlkQB2zuCaMk3hq9F9dVgT6KuFovfdCV5Fecb+rato='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)