UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z5UfXW4JUdU7rMqh40Eq4MY+6jSl28nmz+qpVlKKok4='
WHERE
key_id = '27a6f206e62490498a9c8f9d399fc76e42413ddc3888f22d832bd5c363300ade'
AND (
token = 'z5UfXW4JUdU7rMqh40Eq4MY+6jSl28nmz+qpVlKKok4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)