UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'shIKie5eTWq/x+Ew/zq3zo6TEjGr+joZ30eWecSgw/I='
WHERE
key_id = '3e7cfccc2d7107931f8686e37488264674331e16f14a49b30dc6fd480316f7a2'
AND (
token = 'shIKie5eTWq/x+Ew/zq3zo6TEjGr+joZ30eWecSgw/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)