UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HtPyc5ruIAgt1n1JitPOqh7udcJ2X+c7576i2wrNQvc='
WHERE
key_id = '7e5c16899964cd6c4df03b200d5ab78d3f28008a2a7cbc590624ec6de18e5711'
AND (
token = 'HtPyc5ruIAgt1n1JitPOqh7udcJ2X+c7576i2wrNQvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)