UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NlgctOTCWuexa7DYWgt4L4cbb2+bXNk4V5YJ1lrlXv4='
WHERE
key_id = '5c327e69ef6dfed792a189c1448c4c8394700116f033f26423c38e7b22a48f2b'
AND (
token = 'NlgctOTCWuexa7DYWgt4L4cbb2+bXNk4V5YJ1lrlXv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)