UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sWNsypPYXpKy902WZyrq5Z+RbYjP3xYnac0WVosA4r8='
WHERE
key_id = '5ab6601308e2f314c5b651461ceee789790ef967e4b46ae74ba5edd98a4076d3'
AND (
token = 'sWNsypPYXpKy902WZyrq5Z+RbYjP3xYnac0WVosA4r8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)