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