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