UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2icDnRMoJQi70dyFBd36J5qHuE9NYvviaoW8RmbWwjc='
WHERE
key_id = '05bf23657e462d57d5c45e905c6234584150e9c570a01e87a1f22dc53241ad4c'
AND (
token = '2icDnRMoJQi70dyFBd36J5qHuE9NYvviaoW8RmbWwjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)