UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '16BQQNvgSa6JX7yK4as3jfCHmmQIFXv0Kgx30uLhEbE='
WHERE
key_id = '0eeafcfc436f289bed663bdec126b88a5b27c74da9814c836163beb927962749'
AND (
token = '16BQQNvgSa6JX7yK4as3jfCHmmQIFXv0Kgx30uLhEbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)