UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6UwUkaZ6vCy/OHj02LESipnq997U30ZtBTTCc0F/rlA='
WHERE
key_id = '12dd182b89b1d2cef81b3a910de5392e009564e28dcfa9a8190b0d279878b9f0'
AND (
token = '6UwUkaZ6vCy/OHj02LESipnq997U30ZtBTTCc0F/rlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)