UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8F9WqrcsoLh3oAOUkXgZfUmHYY4xIJL9IA0w+yHnqK8='
WHERE
key_id = '053e7cd2c2ad24f81c41ab6b114d059af3229811a92362f5766167f95dcb890e'
AND (
token = '8F9WqrcsoLh3oAOUkXgZfUmHYY4xIJL9IA0w+yHnqK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)