UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcfMhs4HR2PDsw6+zbhG2vibbbZsCFwcikwAbq+MqGw='
WHERE
key_id = '8a123cb7860a4001264c14b9d82c1ddd0b805ceb08ca34464e91c942c7e53ef3'
AND (
token = 'ZcfMhs4HR2PDsw6+zbhG2vibbbZsCFwcikwAbq+MqGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)