UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6SWqdvf/53Wlzu+bISQ0Gm4L/nt+MiA1l0ZFqNzAZc='
WHERE
key_id = 'b7a3f9819351e87e580ceea379a3e248b31377dfca727d02788220f77aa6c178'
AND (
token = 'K6SWqdvf/53Wlzu+bISQ0Gm4L/nt+MiA1l0ZFqNzAZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)