UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9R5y1HWG5JDVPJypHAZ9EvTW8LDys9Ws3i/IM/F4EKs='
WHERE
key_id = '1c1860ace261fb1767f505e1f2e8ab60154969614cb5442f99cd96109d5baca5'
AND (
token = '9R5y1HWG5JDVPJypHAZ9EvTW8LDys9Ws3i/IM/F4EKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)