UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CAP7KmxAELEm3f5MWM8rEr3j4XmH2nVFBRk9D0snZPo='
WHERE
key_id = 'ed4c02d7acfa6292b7b9cd3ec07aab6ff80b9c0f66a3b0cc5e2307f8143175cc'
AND (
token = 'CAP7KmxAELEm3f5MWM8rEr3j4XmH2nVFBRk9D0snZPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)