UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lGTCOIE1RGXnmiBsPrb1bzk1vZF/JOL6agyWo+L1Wso='
WHERE
key_id = 'fa7023453059fea67e2dffad8921060eff05fceee3ea478980fbda8c87875afe'
AND (
token = 'lGTCOIE1RGXnmiBsPrb1bzk1vZF/JOL6agyWo+L1Wso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)