UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8jO+phH80Lsq2MK25XYWpiqLpJqcnL8b15AcRUTgaXk='
WHERE
key_id = 'd138efd7d5eebce4a9f1fcf999cc4bcf2e4c289153f4e05044e19400c92e0f1b'
AND (
token = '8jO+phH80Lsq2MK25XYWpiqLpJqcnL8b15AcRUTgaXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)