UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+AsiqXpohSDA9dLGjfCvzMvmdIal6TPTSOW6+cRZLgE='
WHERE
key_id = 'c9cccf37c7b9d1bb5b83017bf989a175393eaf302661bad67d93d652316d036a'
AND (
token = '+AsiqXpohSDA9dLGjfCvzMvmdIal6TPTSOW6+cRZLgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)